IF EXISTS ( SELECT  *
            FROM    dbo.sysobjects
            WHERE   id = OBJECT_ID(N'CGO_Charity')
                    AND OBJECTPROPERTY(id, N'IsTable') = 1 ) 
  BEGIN
    DROP TABLE dbo.CGO_Charity
  END
  
CREATE TABLE [dbo].[CGO_Charity](
	[CharityID] [int] IDENTITY(1,1) NOT NULL,
	[PortalID] [int] NOT NULL,
	[UserID] [int] NOT NULL,
	[Name] [nvarchar](90) NOT NULL,	
	[Contact] [nvarchar](50) NULL,
	[WebSite] [nvarchar](255) NULL,
	[Email] [nvarchar](255) NULL,
	[Telephone] [nvarchar] (30) NULL,
	[Fax] [nvarchar] (30) NULL,
	[Address] [nvarchar](255) NULL,
	[Category] [nvarchar](50) NULL,
	[LogoFile] [nvarchar](255) NULL,
	[Description] [ntext] NULL,
	[CreateDate] [datetime] NOT NULL,
	[UpdateDate] [datetime] NOT NULL,
	[Status] [int] NOT NULL
) ON [PRIMARY]

ALTER TABLE [dbo].[CGO_Charity] ADD CONSTRAINT [PK_CGO_Charity] PRIMARY KEY CLUSTERED  ([CharityID]) WITH (FILLFACTOR=90) ON [PRIMARY]